Printing an entire workbook prints hidden sheets due to design.
Cause:
In Microsoft Excel, hidden sheets are designed to be printed when the entire workbook prints. This feature allows the user to print hidden sheets without having to unhide and then re-hide them.
Solution:
To print without the hidden sheets, manually select all the visible sheets. Select 'Print...' from the 'File' menu. Select the 'Selected Sheet(s)' radio button and then print.
1) Manually select all the visible sheets:
a) Click the tab for the first worksheet to print.
b) Press and hold down SHIFT.
c) Click the tab for the last worksheet to print. (All the visible sheets in between are selected.)
2) Select the 'File' menu and select 'Print...'. (The Print dialog box appears.)
3) Select the 'Selected Worksheet(s)' radio button in the 'Print What' group.
the Selected Worksheets radio button
4) (Optional) Type the desired number of copies to print in the 'Number of Copies' box.
NOTE: The number of copies to print defaults to '1'.
5) Click 'OK' to print.
